Lower Mainland Car Crashes

Objectives

  1. Describe behavior of the number of crashes in the specified period
  2. Identify which city had the highest number of crashes and casualties
  3. Describe the evolution of casualties in the specified period
  4. Plot locations with number of crashes above specified number on a map

1. Importing required libraries

2. Data preparation

Data extracted from the source is suitable for analysis (no missing values or errors)

Importing car chrash data from selected cities

3. Exploring the data

Year with largest amount of crashes

City with largest amount of crashes

Street / intersection with highest occurrence of crashes in a year

Street / intersection with highest occurrence of crashes from 2016 to 2020

Crashes that resulted in casualties

4. Crash locations on map

Locations with 500 crashes or more from 2016 to 2020

Crash locations per year

Locations with 100 crashes or more in 2016

Locations with 100 crashes or more in 2017

Locations with 100 crashes or more in 2018

Locations with 100 crashes or more in 2019

Locations with 100 crashes or more in 2020

Conclusion